How is net asset value calculated?

Net asset value is the value of an investment fund determined by subtracting its liabilities from its assets. Per-share NAV is calculated by dividing NAV by the number of shares outstanding. Funds can be open or closed and the pricing of each share is based on NAV.

How to calculate net asset value in Excel?

You can use the following NAV Calculator. Let us now do the same example above in Excel. This is very simple. You need to provide the Four inputs of Market Value of Securities held by the fund, Cash & Equivalent Holdings, Liabilities of the fund’s Number of Outstanding Shares. You can easily calculate the net asset value in the template provided.

What is net asset value (NAV)?

Net asset value definition The net asset value, or NAV for short, is defined as the difference between the assets and liabilities of an investment fund. As an investment fund is usually a pool of money from various investors, we commonly interpret this metric as the market value of the fund.